엑셀 워크시트 복사

VB C#

using IronXL;

WorkBook firstBook = WorkBook.Load("sample.xlsx");
WorkBook secondBook = WorkBook.Create();

// Select first worksheet in the workbook
WorkSheet workSheet = firstBook.DefaultWorkSheet;

// Duplicate the worksheet to the same workbook
workSheet.CopySheet("Copied Sheet");

// Duplicate the worksheet to another workbook with the specified name
workSheet.CopyTo(secondBook, "Copied Sheet");

firstBook.Save();
secondBook.SaveAs("copyExcelWorksheet.xlsx");

Imports IronXL

Private firstBook As WorkBook = WorkBook.Load("sample.xlsx")
Private secondBook As WorkBook = WorkBook.Create()

' Select first worksheet in the workbook
Private workSheet As WorkSheet = firstBook.DefaultWorkSheet

' Duplicate the worksheet to the same workbook
workSheet.CopySheet("Copied Sheet")

' Duplicate the worksheet to another workbook with the specified name
workSheet.CopyTo(secondBook, "Copied Sheet")

firstBook.Save()
secondBook.SaveAs("copyExcelWorksheet.xlsx")

Install-Package IronXL.Excel

엑셀 워크시트 복사

The code example above shows how to use IronXL to duplicate and copy WorkSheets within and between Excel WorkBooks. 다른 통합 문서에서 시트를 복사하고 붙여넣기 합니다. 같은 통합 문서 내에서 중복 시트를 만듭니다.

The CopySheet method is used to duplicate a worksheet within the same workbook or spreadsheet. 새 워크시트의 이름이 매개 변수로 필요합니다.

Use the CopyTo method to duplicate a sheet to or from another workbook. A WorkBook is required as the first parameter and is followed by the name of the new worksheet.

이 링크에서 파일 프로젝트를 다운로드할 수 있습니다.